{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ACCOUNT_ID</th>\n",
       "      <th>USER_NAME</th>\n",
       "      <th>CERT_NO</th>\n",
       "      <th>C_MONTH</th>\n",
       "      <th>C_DAY</th>\n",
       "      <th>OVERDUE</th>\n",
       "      <th>MOB3逾期</th>\n",
       "      <th>MOBILE_NBR</th>\n",
       "      <th>TO_CHAR(A.CREDIT_TIME,'YYYYMMD</th>\n",
       "      <th>ACCEPT_CITY_NAME</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20180101161805724452</td>\n",
       "      <td>樊建彬</td>\n",
       "      <td>62222619921012251X</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.819361e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>张掖市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20180101140922719207</td>\n",
       "      <td>罗文均</td>\n",
       "      <td>511324198209190015</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.818844e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>南充市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20180101122555716202</td>\n",
       "      <td>陈志升</td>\n",
       "      <td>330326197509174010</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.335333e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>温州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>20180101165539725863</td>\n",
       "      <td>季春宝</td>\n",
       "      <td>330782199011034338</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1.800652e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>金华市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20180101172751726766</td>\n",
       "      <td>邱康和</td>\n",
       "      <td>511028197402012717</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.898291e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>成都市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>20180101120507715516</td>\n",
       "      <td>李华康</td>\n",
       "      <td>440924197711151934</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.536216e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>20180101122734716235</td>\n",
       "      <td>刘永利</td>\n",
       "      <td>511181198602052117</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.337835e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>乐山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>20180101083442709886</td>\n",
       "      <td>许海芳</td>\n",
       "      <td>330724197710020020</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.806624e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>金华市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>20180101154227722757</td>\n",
       "      <td>杨月荣</td>\n",
       "      <td>13282919710727153X</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.538307e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>廊坊市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>20180101105839713046</td>\n",
       "      <td>潘容容</td>\n",
       "      <td>511027198311209061</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.895737e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>嘉兴市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>20180101101610711395</td>\n",
       "      <td>池万靖</td>\n",
       "      <td>33038119891109451X</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.807216e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>温州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>20180101174242727197</td>\n",
       "      <td>李建东</td>\n",
       "      <td>130702197911200612</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.773137e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>张家口市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>20180101155952723644</td>\n",
       "      <td>王泳淳</td>\n",
       "      <td>142430199011261251</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.331351e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>太原市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>20180101154821723322</td>\n",
       "      <td>常磊杰</td>\n",
       "      <td>410526198810247691</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.333592e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>金华市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>20180101114218714872</td>\n",
       "      <td>吴爱婷</td>\n",
       "      <td>330225197811158626</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.896848e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>台州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>20180101181625727885</td>\n",
       "      <td>崔向伟</td>\n",
       "      <td>41032719811105145X</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.330388e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>洛阳市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20180101161126724116</td>\n",
       "      <td>胡平武</td>\n",
       "      <td>43282619680510367X</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.892583e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20180101165945726016</td>\n",
       "      <td>邓仁国</td>\n",
       "      <td>511324197108130019</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.899071e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>南充市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>20180101164559725609</td>\n",
       "      <td>陈荣摊</td>\n",
       "      <td>330327198004112130</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.895860e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>台州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20180101203226729058</td>\n",
       "      <td>杨七十</td>\n",
       "      <td>622701196706251637</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.899336e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>平凉市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20180101132321717568</td>\n",
       "      <td>王贤孝</td>\n",
       "      <td>330382199108110374</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.532500e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>温州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>20180101125504716955</td>\n",
       "      <td>汪云辉</td>\n",
       "      <td>500236198411064677</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.538316e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>唐山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>20180101134136718183</td>\n",
       "      <td>陆军</td>\n",
       "      <td>650102196908091624</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.332561e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>乌鲁木齐市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>20180101172056726800</td>\n",
       "      <td>阳勇</td>\n",
       "      <td>511024197912230196</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.818178e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>绵阳市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>20180101134255718196</td>\n",
       "      <td>熊胜利</td>\n",
       "      <td>320382198408165952</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.330574e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>宁波市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>20180101151538721722</td>\n",
       "      <td>包启锷</td>\n",
       "      <td>330382198305053132</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.895893e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>温州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>20180101183825728178</td>\n",
       "      <td>张治国</td>\n",
       "      <td>432302197702203519</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.353182e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>20180101121001715590</td>\n",
       "      <td>赵兴儒</td>\n",
       "      <td>622223198605272316</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.819367e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>张掖市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>20180101175654727668</td>\n",
       "      <td>王善樑</td>\n",
       "      <td>330723199510294118</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.775794e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>金华市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>20180101163617725057</td>\n",
       "      <td>丁浩</td>\n",
       "      <td>330382198210093238</td>\n",
       "      <td>201800</td>\n",
       "      <td>20180101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.807207e+10</td>\n",
       "      <td>20180101.0</td>\n",
       "      <td>温州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651977</th>\n",
       "      <td>20190430111211958262</td>\n",
       "      <td>冯艳霞</td>\n",
       "      <td>441900198302133844</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.899803e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651978</th>\n",
       "      <td>20190430111155958053</td>\n",
       "      <td>王友军</td>\n",
       "      <td>320830197507103411</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.538068e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651979</th>\n",
       "      <td>20190430103650956158</td>\n",
       "      <td>华琪林</td>\n",
       "      <td>320222197505185975</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.801533e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651980</th>\n",
       "      <td>20190430143107975782</td>\n",
       "      <td>卞发广</td>\n",
       "      <td>32080419900419571X</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.771564e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651981</th>\n",
       "      <td>20190430142629975534</td>\n",
       "      <td>吴霄伟</td>\n",
       "      <td>320202197011120033</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.892112e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651982</th>\n",
       "      <td>20190430145604978462</td>\n",
       "      <td>董海民</td>\n",
       "      <td>410422196702168611</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.802893e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651983</th>\n",
       "      <td>20190430162034987438</td>\n",
       "      <td>莫兵</td>\n",
       "      <td>511322198410102598</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.338012e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651984</th>\n",
       "      <td>20190430094819951948</td>\n",
       "      <td>胡玉静</td>\n",
       "      <td>442000197303216665</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.359082e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651985</th>\n",
       "      <td>20190430094007951294</td>\n",
       "      <td>陈志成</td>\n",
       "      <td>441900198005060714</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.893816e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651986</th>\n",
       "      <td>20190430111444958639</td>\n",
       "      <td>朱小平</td>\n",
       "      <td>320826198507151624</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.801417e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651987</th>\n",
       "      <td>20190430155326984679</td>\n",
       "      <td>殷丽贤</td>\n",
       "      <td>450921199209103269</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.812523e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651988</th>\n",
       "      <td>20190430130303968820</td>\n",
       "      <td>顾铭铭</td>\n",
       "      <td>320981199704124478</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.779870e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651989</th>\n",
       "      <td>20190430150457979380</td>\n",
       "      <td>纪开明</td>\n",
       "      <td>32082919741021104X</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.525160e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651990</th>\n",
       "      <td>20190430154741983788</td>\n",
       "      <td>黄志彬</td>\n",
       "      <td>441900199206304118</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.365043e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651991</th>\n",
       "      <td>20190430165937991716</td>\n",
       "      <td>陈慧</td>\n",
       "      <td>362302198709150022</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.392923e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651992</th>\n",
       "      <td>20190430155013984301</td>\n",
       "      <td>钟燕芳</td>\n",
       "      <td>441621198109091027</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.802666e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>惠州市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651993</th>\n",
       "      <td>20190430165239990932</td>\n",
       "      <td>李文静</td>\n",
       "      <td>532327199701151323</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.898781e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651994</th>\n",
       "      <td>20190430180401997416</td>\n",
       "      <td>代贞其</td>\n",
       "      <td>510223197311034150</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.336822e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651995</th>\n",
       "      <td>20190430172629994224</td>\n",
       "      <td>金加富</td>\n",
       "      <td>330327198001276092</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.896170e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651996</th>\n",
       "      <td>20190430192340101919</td>\n",
       "      <td>柳佳</td>\n",
       "      <td>320281198904231021</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.892126e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651997</th>\n",
       "      <td>20190430173200994822</td>\n",
       "      <td>杨芳</td>\n",
       "      <td>362132198206290063</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.892580e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651998</th>\n",
       "      <td>20190430164452990110</td>\n",
       "      <td>罗艳香</td>\n",
       "      <td>441424197207071023</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.892915e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>东莞市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651999</th>\n",
       "      <td>20190430174233995529</td>\n",
       "      <td>罗琼</td>\n",
       "      <td>510216197304250820</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.399641e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652000</th>\n",
       "      <td>20190430162012987409</td>\n",
       "      <td>孙永刚</td>\n",
       "      <td>320223196607113974</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.891532e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652001</th>\n",
       "      <td>20190430171035992833</td>\n",
       "      <td>杨荣</td>\n",
       "      <td>510202197003234423</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.336826e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>重庆市辖区</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652002</th>\n",
       "      <td>20190430115046963154</td>\n",
       "      <td>赵永财</td>\n",
       "      <td>34122219820517435X</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1.332690e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>中山市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652003</th>\n",
       "      <td>20190430160713985945</td>\n",
       "      <td>苏士奎</td>\n",
       "      <td>320826198702120831</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.531230e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652004</th>\n",
       "      <td>20190430175311996603</td>\n",
       "      <td>王致远</td>\n",
       "      <td>320282199802151566</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.373912e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>无锡市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652005</th>\n",
       "      <td>20190430184520999861</td>\n",
       "      <td>葛建强</td>\n",
       "      <td>320804199502172115</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.536593e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652006</th>\n",
       "      <td>20190430193543102332</td>\n",
       "      <td>张银梅</td>\n",
       "      <td>320831197106283649</td>\n",
       "      <td>201903</td>\n",
       "      <td>20190430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.801518e+10</td>\n",
       "      <td>20190430.0</td>\n",
       "      <td>淮安市</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1652007 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   ACCOUNT_ID USER_NAME             CERT_NO  C_MONTH  \\\n",
       "0        20180101161805724452       樊建彬  62222619921012251X   201800   \n",
       "1        20180101140922719207       罗文均  511324198209190015   201800   \n",
       "2        20180101122555716202       陈志升  330326197509174010   201800   \n",
       "3        20180101165539725863       季春宝  330782199011034338   201800   \n",
       "4        20180101172751726766       邱康和  511028197402012717   201800   \n",
       "5        20180101120507715516       李华康  440924197711151934   201800   \n",
       "6        20180101122734716235       刘永利  511181198602052117   201800   \n",
       "7        20180101083442709886       许海芳  330724197710020020   201800   \n",
       "8        20180101154227722757       杨月荣  13282919710727153X   201800   \n",
       "9        20180101105839713046       潘容容  511027198311209061   201800   \n",
       "10       20180101101610711395       池万靖  33038119891109451X   201800   \n",
       "11       20180101174242727197       李建东  130702197911200612   201800   \n",
       "12       20180101155952723644       王泳淳  142430199011261251   201800   \n",
       "13       20180101154821723322       常磊杰  410526198810247691   201800   \n",
       "14       20180101114218714872       吴爱婷  330225197811158626   201800   \n",
       "15       20180101181625727885       崔向伟  41032719811105145X   201800   \n",
       "16       20180101161126724116       胡平武  43282619680510367X   201800   \n",
       "17       20180101165945726016       邓仁国  511324197108130019   201800   \n",
       "18       20180101164559725609       陈荣摊  330327198004112130   201800   \n",
       "19       20180101203226729058       杨七十  622701196706251637   201800   \n",
       "20       20180101132321717568       王贤孝  330382199108110374   201800   \n",
       "21       20180101125504716955       汪云辉  500236198411064677   201800   \n",
       "22       20180101134136718183        陆军  650102196908091624   201800   \n",
       "23       20180101172056726800        阳勇  511024197912230196   201800   \n",
       "24       20180101134255718196       熊胜利  320382198408165952   201800   \n",
       "25       20180101151538721722       包启锷  330382198305053132   201800   \n",
       "26       20180101183825728178       张治国  432302197702203519   201800   \n",
       "27       20180101121001715590       赵兴儒  622223198605272316   201800   \n",
       "28       20180101175654727668       王善樑  330723199510294118   201800   \n",
       "29       20180101163617725057        丁浩  330382198210093238   201800   \n",
       "...                       ...       ...                 ...      ...   \n",
       "1651977  20190430111211958262       冯艳霞  441900198302133844   201903   \n",
       "1651978  20190430111155958053       王友军  320830197507103411   201903   \n",
       "1651979  20190430103650956158       华琪林  320222197505185975   201903   \n",
       "1651980  20190430143107975782       卞发广  32080419900419571X   201903   \n",
       "1651981  20190430142629975534       吴霄伟  320202197011120033   201903   \n",
       "1651982  20190430145604978462       董海民  410422196702168611   201903   \n",
       "1651983  20190430162034987438        莫兵  511322198410102598   201903   \n",
       "1651984  20190430094819951948       胡玉静  442000197303216665   201903   \n",
       "1651985  20190430094007951294       陈志成  441900198005060714   201903   \n",
       "1651986  20190430111444958639       朱小平  320826198507151624   201903   \n",
       "1651987  20190430155326984679       殷丽贤  450921199209103269   201903   \n",
       "1651988  20190430130303968820       顾铭铭  320981199704124478   201903   \n",
       "1651989  20190430150457979380       纪开明  32082919741021104X   201903   \n",
       "1651990  20190430154741983788       黄志彬  441900199206304118   201903   \n",
       "1651991  20190430165937991716        陈慧  362302198709150022   201903   \n",
       "1651992  20190430155013984301       钟燕芳  441621198109091027   201903   \n",
       "1651993  20190430165239990932       李文静  532327199701151323   201903   \n",
       "1651994  20190430180401997416       代贞其  510223197311034150   201903   \n",
       "1651995  20190430172629994224       金加富  330327198001276092   201903   \n",
       "1651996  20190430192340101919        柳佳  320281198904231021   201903   \n",
       "1651997  20190430173200994822        杨芳  362132198206290063   201903   \n",
       "1651998  20190430164452990110       罗艳香  441424197207071023   201903   \n",
       "1651999  20190430174233995529        罗琼  510216197304250820   201903   \n",
       "1652000  20190430162012987409       孙永刚  320223196607113974   201903   \n",
       "1652001  20190430171035992833        杨荣  510202197003234423   201903   \n",
       "1652002  20190430115046963154       赵永财  34122219820517435X   201903   \n",
       "1652003  20190430160713985945       苏士奎  320826198702120831   201903   \n",
       "1652004  20190430175311996603       王致远  320282199802151566   201903   \n",
       "1652005  20190430184520999861       葛建强  320804199502172115   201903   \n",
       "1652006  20190430193543102332       张银梅  320831197106283649   201903   \n",
       "\n",
       "            C_DAY  OVERDUE  MOB3逾期    MOBILE_NBR  \\\n",
       "0        20180101        0       0  1.819361e+10   \n",
       "1        20180101        0       0  1.818844e+10   \n",
       "2        20180101        0       0  1.335333e+10   \n",
       "3        20180101       12       0  1.800652e+10   \n",
       "4        20180101        0       0  1.898291e+10   \n",
       "5        20180101        0       0  1.536216e+10   \n",
       "6        20180101        0       0  1.337835e+10   \n",
       "7        20180101        0       0  1.806624e+10   \n",
       "8        20180101        0       0  1.538307e+10   \n",
       "9        20180101        0       0  1.895737e+10   \n",
       "10       20180101        0       0  1.807216e+10   \n",
       "11       20180101        0       0  1.773137e+10   \n",
       "12       20180101        0       0  1.331351e+10   \n",
       "13       20180101        0       0  1.333592e+10   \n",
       "14       20180101        0       0  1.896848e+10   \n",
       "15       20180101        0       0  1.330388e+10   \n",
       "16       20180101        0       0  1.892583e+10   \n",
       "17       20180101        0       0  1.899071e+10   \n",
       "18       20180101        0       0  1.895860e+10   \n",
       "19       20180101        0       0  1.899336e+10   \n",
       "20       20180101        0       0  1.532500e+10   \n",
       "21       20180101        0       0  1.538316e+10   \n",
       "22       20180101        0       0  1.332561e+10   \n",
       "23       20180101        0       0  1.818178e+10   \n",
       "24       20180101        0       0  1.330574e+10   \n",
       "25       20180101        0       0  1.895893e+10   \n",
       "26       20180101        0       0  1.353182e+10   \n",
       "27       20180101        0       0  1.819367e+10   \n",
       "28       20180101        0       0  1.775794e+10   \n",
       "29       20180101        0       0  1.807207e+10   \n",
       "...           ...      ...     ...           ...   \n",
       "1651977  20190430        0       0  1.899803e+10   \n",
       "1651978  20190430        0       0  1.538068e+10   \n",
       "1651979  20190430        0       0  1.801533e+10   \n",
       "1651980  20190430        0       0  1.771564e+10   \n",
       "1651981  20190430        0       0  1.892112e+10   \n",
       "1651982  20190430        0       0  1.802893e+10   \n",
       "1651983  20190430        0       0  1.338012e+10   \n",
       "1651984  20190430        0       0  1.359082e+10   \n",
       "1651985  20190430        0       0  1.893816e+10   \n",
       "1651986  20190430        0       0  1.801417e+10   \n",
       "1651987  20190430        0       0  1.812523e+10   \n",
       "1651988  20190430        0       0  1.779870e+10   \n",
       "1651989  20190430        0       0  1.525160e+10   \n",
       "1651990  20190430        0       0  1.365043e+10   \n",
       "1651991  20190430        0       0  1.392923e+10   \n",
       "1651992  20190430        0       0  1.802666e+10   \n",
       "1651993  20190430        0       0  1.898781e+10   \n",
       "1651994  20190430        0       0  1.336822e+10   \n",
       "1651995  20190430        0       0  1.896170e+10   \n",
       "1651996  20190430        0       0  1.892126e+10   \n",
       "1651997  20190430        0       0  1.892580e+10   \n",
       "1651998  20190430        0       0  1.892915e+10   \n",
       "1651999  20190430        0       0  1.399641e+10   \n",
       "1652000  20190430        0       0  1.891532e+10   \n",
       "1652001  20190430        0       0  1.336826e+10   \n",
       "1652002  20190430        0       1  1.332690e+10   \n",
       "1652003  20190430        0       0  1.531230e+10   \n",
       "1652004  20190430        0       0  1.373912e+10   \n",
       "1652005  20190430        0       0  1.536593e+10   \n",
       "1652006  20190430        0       0  1.801518e+10   \n",
       "\n",
       "         TO_CHAR(A.CREDIT_TIME,'YYYYMMD ACCEPT_CITY_NAME  \n",
       "0                            20180101.0              张掖市  \n",
       "1                            20180101.0              南充市  \n",
       "2                            20180101.0              温州市  \n",
       "3                            20180101.0              金华市  \n",
       "4                            20180101.0              成都市  \n",
       "5                            20180101.0              中山市  \n",
       "6                            20180101.0              乐山市  \n",
       "7                            20180101.0              金华市  \n",
       "8                            20180101.0              廊坊市  \n",
       "9                            20180101.0              嘉兴市  \n",
       "10                           20180101.0              温州市  \n",
       "11                           20180101.0             张家口市  \n",
       "12                           20180101.0              太原市  \n",
       "13                           20180101.0              金华市  \n",
       "14                           20180101.0              台州市  \n",
       "15                           20180101.0              洛阳市  \n",
       "16                           20180101.0              东莞市  \n",
       "17                           20180101.0              南充市  \n",
       "18                           20180101.0              台州市  \n",
       "19                           20180101.0              平凉市  \n",
       "20                           20180101.0              温州市  \n",
       "21                           20180101.0              唐山市  \n",
       "22                           20180101.0            乌鲁木齐市  \n",
       "23                           20180101.0              绵阳市  \n",
       "24                           20180101.0              宁波市  \n",
       "25                           20180101.0              温州市  \n",
       "26                           20180101.0              中山市  \n",
       "27                           20180101.0              张掖市  \n",
       "28                           20180101.0              金华市  \n",
       "29                           20180101.0              温州市  \n",
       "...                                 ...              ...  \n",
       "1651977                      20190430.0              东莞市  \n",
       "1651978                      20190430.0              淮安市  \n",
       "1651979                      20190430.0              无锡市  \n",
       "1651980                      20190430.0              淮安市  \n",
       "1651981                      20190430.0              无锡市  \n",
       "1651982                      20190430.0              东莞市  \n",
       "1651983                      20190430.0              东莞市  \n",
       "1651984                      20190430.0              中山市  \n",
       "1651985                      20190430.0              东莞市  \n",
       "1651986                      20190430.0              淮安市  \n",
       "1651987                      20190430.0              中山市  \n",
       "1651988                      20190430.0              无锡市  \n",
       "1651989                      20190430.0              淮安市  \n",
       "1651990                      20190430.0              东莞市  \n",
       "1651991                      20190430.0              东莞市  \n",
       "1651992                      20190430.0              惠州市  \n",
       "1651993                      20190430.0              东莞市  \n",
       "1651994                      20190430.0            重庆市辖区  \n",
       "1651995                      20190430.0              无锡市  \n",
       "1651996                      20190430.0              无锡市  \n",
       "1651997                      20190430.0              东莞市  \n",
       "1651998                      20190430.0              东莞市  \n",
       "1651999                      20190430.0            重庆市辖区  \n",
       "1652000                      20190430.0              无锡市  \n",
       "1652001                      20190430.0            重庆市辖区  \n",
       "1652002                      20190430.0              中山市  \n",
       "1652003                      20190430.0              淮安市  \n",
       "1652004                      20190430.0              无锡市  \n",
       "1652005                      20190430.0              淮安市  \n",
       "1652006                      20190430.0              淮安市  \n",
       "\n",
       "[1652007 rows x 10 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "\n",
    "os.chdir('D:\\合并数据')\n",
    "df1 = pd.read_csv('overdue.csv')\n",
    "df2 = pd.read_csv('mob.csv')\n",
    "df3 = pd.read_csv('mobile_nbr.csv')\n",
    "df4 = pd.read_csv('city.csv')\n",
    "\n",
    "# df1=pd.DataFrame({\n",
    "#     \"id\":[1,2,3],\n",
    "#     \"num\":[4,5,6]}\n",
    "# )\n",
    "# df2=pd.DataFrame({\n",
    "#     \"id\":[1,2,3],\n",
    "#     \"num\":[7,8,9]}\n",
    "# )\n",
    "# df3=pd.DataFrame({\n",
    "#     \"id\":[1,2,3],\n",
    "#     \"num\":[10,11,12]}\n",
    "# )\n",
    "\n",
    "df1_2 = pd.merge(df1, df2, on=[\"ACCOUNT_ID\"], how='left',sort=False,copy=False)\n",
    "df1_3  = pd.merge(df1_2, df3, on=[\"ACCOUNT_ID\"], how='left',sort=False,copy=False)\n",
    "last  = pd.merge(df1_3, df4, on=[\"ACCOUNT_ID\"], how='left',sort=False,copy=False)\n",
    "last\n",
    "# last.rename(columns={\"num\":\"n\"},inplace=True)\n",
    "# last"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "last.drop(columns=['C_MONTH','ACCOUNT_ID'],inplace=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "last.to_csv('last.csv',encoding='utf_8_sig',index=None)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
